A Relational Database Semantic Re-Engineering Technology and Tools
نویسندگان
چکیده
We describe a relational database semantic re-engineering technology and the tools that are available for its implementation. The semantic re-engineering technological process starts with creatinga conceptual data ontology together with its annotations for database schema and user interface mappings. The database schema mappings are implemented in RDB2OWL and D2RQ server thus creating a SPARQL-endpoint for “semantic” access to the relational database contents. The SPARQL endpoint can be explored by the user interface automatically generated by OBIS system, or ViziQuer tool may be used for custom SPARQL query generation in a graphical way. We report on successful application of the approach on the Latvian medical data with the ontology containing 172 OWL classes, 138 object properties, 814 data properties, and about 40 million data level RDF triples.
منابع مشابه
Metadata Enrichment for Automatic Data Entry Based on Relational Data Models
The idea of automatic generation of data entry forms based on data relational models is a common and known idea that has been discussed day by day more than before according to the popularity of agile methods in software development accompanying development of programming tools. One of the requirements of the automation methods, whether in commercial products or the relevant research projects, ...
متن کاملUML Specification of Relational Database
Database reverse engineering (DBRE) recovers a database design using a semantic data model. Most of the existing works and tools for DBRE and database design specify relational database schemas with extended ER models. The Unified Modeling Language (UML) is a standard language for modeling software and database systems. We discuss how to extend the UML metamodel with elements for modeling relat...
متن کاملSuitable Databases for Process-Centered Environments Do not yet Exist
As early as 1987, Bernstein has argued that dedicated database systems for software engineering, specialised with respect to functionality as well as implementation, are necessary [7]. He argued that the functionality and e ciency of existing systems (in particular, relational systems) does not adequately support the construction of software engineering tools and environments. Many researchers ...
متن کاملReverse engineering of relational databaseapplicationsMark
This paper presents techniques for reverse engineering of re-lational database applications. The target of such an eeort is the deeni-tion of a fully equipped object-oriented view of the relational database, including methods and constraints. Such views can be seen as a full speci-cation of the database semantics, aiding for example in the identiication of semantic heterogeneity among interoper...
متن کاملSemantic Grep: Regular Expressions + Relational Abstraction
Searching source code is one of the most common activities of software engineers. Text editors and other support tools normally provide searching based on lexical expressions (regular expressions). Some more advanced editors provide a way to add semantic direction to some of the searches. Recent research has focused on advancing the semantic options available to text-based queries. Most of thes...
متن کامل